Snowflake schema

en

WikiRank.net
ver. 1.6.2

Snowflake schema

Quality:

Snowflake schema - logical arrangement of computing tables in a multidimensional database. Article “Snowflake schema” in English Wikipedia has 26.6 points for quality (as of July 1, 2025). The article contains 4 references and 8 sections. The article also contains templates indicating quality issues, therefore its score was reduced by 1.4 points.

This article has the best quality in Czech Wikipedia. However, this article is the most popular in English version.

Since the creation of article “Snowflake schema”, its content was written by 78 registered users of English Wikipedia and edited by 185 registered Wikipedia users in all languages.

The article is cited 60 times in English Wikipedia and cited 175 times in all languages.

The highest Authors Interest rank from 2001:

  • Local (English): #62704 in January 2006
  • Global: #55561 in May 2004

The highest popularity rank from 2008:

  • Local (English): #31551 in May 2015
  • Global: #61209 in May 2015

There are 13 language versions for this article in the WikiRank database (of the considered 55 Wikipedia language editions).

The quality and popularity assessment was based on Wikipédia dumps from July 1, 2025 (including revision history and pageviews for previous years).

The table below shows the language versions of the article with the highest quality.

Languages with the highest quality

#LanguageQuality gradeQuality score
1Czech (cs)
Schéma sněhové vločky
32.7433
2Norwegian (no)
Snøflakmodell
28.5973
3English (en)
Snowflake schema
26.6103
4Ukrainian (uk)
Схема сніжинки
18.0971
5German (de)
Schneeflockenschema
14.8288
6Japanese (ja)
スノーフレークスキーマ
13.0355
7Hebrew (he)
סכמת פתית השלג
12.5101
8Polish (pl)
Schemat płatka śniegu
9.9742
9Spanish (es)
Esquema en copo de nieve
5.9754
10Korean (ko)
눈송이 스키마
4.7774
More...

The following table shows the most popular language versions of the article.

Most popular in all the time

The most popular language versions of the article "Snowflake schema" in all the time
#LanguagePopularity awardRelative popularity
1English (en)
Snowflake schema
1 711 594
2Spanish (es)
Esquema en copo de nieve
179 611
3German (de)
Schneeflockenschema
158 042
4Russian (ru)
Схема снежинки
152 651
5Polish (pl)
Schemat płatka śniegu
34 613
6Italian (it)
Schema a fiocco di neve
19 429
7Hebrew (he)
סכמת פתית השלג
12 921
8Korean (ko)
눈송이 스키마
8 132
9Czech (cs)
Schéma sněhové vločky
7 480
10Japanese (ja)
スノーフレークスキーマ
7 261
More...

The following table shows the language versions of the article with the highest popularity in the last month.

Most popular in June 2025

The most popular language versions of the article "Snowflake schema" in June 2025
#LanguagePopularity awardRelative popularity
1English (en)
Snowflake schema
3 235
2Russian (ru)
Схема снежинки
271
3German (de)
Schneeflockenschema
218
4Polish (pl)
Schemat płatka śniegu
126
5Japanese (ja)
スノーフレークスキーマ
90
6Spanish (es)
Esquema en copo de nieve
88
7Italian (it)
Schema a fiocco di neve
56
8Czech (cs)
Schéma sněhové vločky
23
9Ukrainian (uk)
Схема сніжинки
22
10Korean (ko)
눈송이 스키마
16
More...

The following table shows the language versions of the article with the highest Authors’ Interest.

The highest AI

Language versions of the article "Snowflake schema" with the highest Authors Interest (number of authors). Only registered Wikipedia users were taken into account.
#LanguageAI awardRelative AI
1English (en)
Snowflake schema
78
2German (de)
Schneeflockenschema
29
3Russian (ru)
Схема снежинки
13
4Italian (it)
Schema a fiocco di neve
12
5Hebrew (he)
סכמת פתית השלג
11
6Polish (pl)
Schemat płatka śniegu
9
7Spanish (es)
Esquema en copo de nieve
8
8Czech (cs)
Schéma sněhové vločky
7
9Norwegian (no)
Snøflakmodell
5
10Persian (fa)
طرح دانه برفی
4
More...

The following table shows the language versions of the article with the highest Authors’ Interest in the last month.

The highest AI in June 2025

Language versions of the article "Snowflake schema" with the highest AI in June 2025
#LanguageAI awardRelative AI
1Czech (cs)
Schéma sněhové vločky
0
2German (de)
Schneeflockenschema
0
3English (en)
Snowflake schema
0
4Spanish (es)
Esquema en copo de nieve
0
5Persian (fa)
طرح دانه برفی
0
6Hebrew (he)
סכמת פתית השלג
0
7Italian (it)
Schema a fiocco di neve
0
8Japanese (ja)
スノーフレークスキーマ
0
9Korean (ko)
눈송이 스키마
0
10Norwegian (no)
Snøflakmodell
0
More...

The following table shows the language versions of the article with the highest number of citations.

The highest CI

Language versions of the article "Snowflake schema" with the highest Citation Index (CI)
#LanguageCI awardRelative CI
1English (en)
Snowflake schema
60
2Norwegian (no)
Snøflakmodell
48
3Russian (ru)
Схема снежинки
21
4Spanish (es)
Esquema en copo de nieve
10
5German (de)
Schneeflockenschema
7
6Hebrew (he)
סכמת פתית השלג
6
7Korean (ko)
눈송이 스키마
6
8Ukrainian (uk)
Схема сніжинки
6
9Persian (fa)
طرح دانه برفی
5
10Czech (cs)
Schéma sněhové vločky
4
More...

Scores

Estimated value for Wikipedia:
English:
Global:
Popularity in June 2025:
English:
Global:
Popularity in all years:
English:
Global:
Authors in June 2025:
English:
Global:
Registered authors in all years:
English:
Global:
Citations:
English:
Global:

Quality measures

Interwikis

#LanguageValue
csCzech
Schéma sněhové vločky
deGerman
Schneeflockenschema
enEnglish
Snowflake schema
esSpanish
Esquema en copo de nieve
faPersian
طرح دانه برفی
heHebrew
סכמת פתית השלג
itItalian
Schema a fiocco di neve
jaJapanese
スノーフレークスキーマ
koKorean
눈송이 스키마
noNorwegian
Snøflakmodell
plPolish
Schemat płatka śniegu
ruRussian
Схема снежинки
ukUkrainian
Схема сніжинки

Popularity rank trends

Best Rank English:
#31551
05.2015
Global:
#61209
05.2015

AI rank trends

Best Rank English:
#62704
01.2006
Global:
#55561
05.2004

Languages comparison

Important global interconnections (July 2024 – June 2025)

Wikipedia readers most often find their way to information on Snowflake schema from Wikipedia articles about Star schema, Online analytical processing, Data mart, OLAP cube and Fact table. Whereas reading the article about Snowflake schema people most often go to Wikipedia articles on Star schema, Online analytical processing, Fact table, Third normal form and Database normalisation.

Cumulative results of quality and popularity of the Wikipedia article

List of Wikipedia articles in different languages (starting with the most popular):

News from 5 March 2026

On 5 March 2026 in multilingual Wikipedia, Internet users most often read articles on the following topics: Iran, Ali Khamenei, 2026 Iran war, Jeffrey Epstein, Kurds, Strait of Hormuz, Yakovlev Yak-130, Donald Trump, Azerbaijan, Kristi Noem.

In English Wikipedia the most popular articles on that day were: Markwayne Mullin, Kristi Noem, 2026 Iran war, Ali Khamenei, Lou Holtz, Men's T20 World Cup, Iran, IRIS Dena, Corey Lewandowski, Deaths in 2026.

About WikiRank

The WikiRank project is intended for automatic relative evaluation of the articles in the various language versions of Wikipedia. At the moment the service allows to compare over 44 million Wikipedia articles in 55 languages. Quality scores of articles are based on Wikipedia dumps from July, 2025. When calculating current popularity and AI of articles data from June 2025 was taken into account. For historical values of popularity and AI WikiRank used data from 2001 to 2025... More information